Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1117894
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	127.9 MiB
Average record size in memory	120.0 B

Variable types

Categorical	3
Numeric	12

Alerts

`zyklus_` is highly correlated with `time_amin` and 3 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`time_amin` is highly correlated with `zyklus_` and 5 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `zyklus_` and 4 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `zyklus_` and 3 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `zyklus_` and 5 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 2 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`time_temp_hoch_vorher` is highly correlated with `time_amin` and 3 other fields	High correlation
`zyklus_` is highly correlated with `time_amin` and 3 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 1 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`time_amin` is highly correlated with `zyklus_` and 4 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `zyklus_` and 3 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `zyklus_` and 2 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `zyklus_` and 3 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 1 other fields	High correlation
`zyklus_` is highly correlated with `time_amin` and 3 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`time_amin` is highly correlated with `zyklus_` and 4 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `zyklus_` and 3 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `zyklus_` and 3 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `zyklus_` and 4 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 1 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`comment_` is highly correlated with `type_`	High correlation
`type_` is highly correlated with `comment_`	High correlation
`batteryname_` is highly correlated with `zyklus_` and 7 other fields	High correlation
`amperestunden` is highly correlated with `comment_` and 1 other fields	High correlation
`zyklus_` is highly correlated with `batteryname_` and 6 other fields	High correlation
`comment_` is highly correlated with `amperestunden` and 2 other fields	High correlation
`type_` is highly correlated with `amperestunden` and 1 other fields	High correlation
`temperature_amax` is highly correlated with `batteryname_` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `batteryname_` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `batteryname_` and 2 other fields	High correlation
`time_amin` is highly correlated with `zyklus_` and 5 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `zyklus_` and 5 other fields	High correlation
`time_pause_vorher` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_temp_hoch` is highly correlated with `comment_`	High correlation
`time_temp_hoch_vorher` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_temp_hoch` is highly skewed (γ1 = 46.20583322)	Skewed
`amperestunden` has 561175 (50.2%) zeros	Zeros
`time_temp_hoch` has 475649 (42.5%) zeros	Zeros

Reproduction

Analysis started	2021-12-16 20:35:20.572309
Analysis finished	2021-12-16 20:37:20.420741
Duration	1 minute and 59.85 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

batteryname_
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

RW9	113578
RW10	110818
RW12	110013
RW11	109389
RW13	56049
Other values (23)	618047

Length

Max length	4
Median length	4
Mean length	3.799878164
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RW1
2nd row	RW1
3rd row	RW1
4th row	RW1
5th row	RW1

Common Values

Value	Count	Frequency (%)
RW9	113578	10.2%
RW10	110818	9.9%
RW12	110013	9.8%
RW11	109389	9.8%
RW13	56049	5.0%
RW15	47720	4.3%
RW14	45868	4.1%
RW21	42700	3.8%
RW16	42366	3.8%
RW23	41694	3.7%
Other values (18)	397699	35.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rw9	113578	10.2%
rw10	110818	9.9%
rw12	110013	9.8%
rw11	109389	9.8%
rw13	56049	5.0%
rw15	47720	4.3%
rw14	45868	4.1%
rw21	42700	3.8%
rw16	42366	3.8%
rw23	41694	3.7%
Other values (18)	397699	35.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

amperestunden
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	133952
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0008962882368

Minimum	-2.147068874
Maximum	2.147192722
Zeros	561175
Zeros (%)	50.2%
Negative	132910
Negative (%)	11.9%
Memory size	8.5 MiB

Quantile statistics

Minimum	-2.147068874
5-th percentile	-0.07607496247
Q1	0
median	0
Q3	0.03333415301
95-th percentile	0.1249883721
Maximum	2.147192722
Range	4.294261596
Interquartile range (IQR)	0.03333415301

Descriptive statistics

Standard deviation	0.1607122953
Coefficient of variation (CV)	179.3087187
Kurtosis	70.73545931
Mean	0.0008962882368
Median Absolute Deviation (MAD)	0
Skewness	-5.806977835
Sum	1001.955242
Variance	0.02582844187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	561175	50.2%
0.03333469945	6578	0.6%
0.03333442623	6554	0.6%
0.03333497268	5728	0.5%
0.03333415301	5289	0.5%
0.0333352459	4412	0.4%
0.05833442623	4166	0.4%
0.05833469945	4108	0.4%
0.02499945355	3951	0.4%
0.02499918033	3916	0.4%
Other values (133942)	512017	45.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.147068874	1	< 0.1%
-2.146239065	1	< 0.1%
-2.143412219	1	< 0.1%
-2.143024259	1	< 0.1%
-2.142788818	1	< 0.1%
-2.142226376	1	< 0.1%
-2.139796562	1	< 0.1%
-2.13836283	1	< 0.1%
-2.137620586	1	< 0.1%
-2.137435847	1	< 0.1%

Value	Count	Frequency (%)
2.147192722	1	< 0.1%
2.141582404	1	< 0.1%
2.138831784	1	< 0.1%
2.137437355	1	< 0.1%
2.136908838	1	< 0.1%
2.134823039	1	< 0.1%
2.134648283	1	< 0.1%
2.133916152	1	< 0.1%
2.132614816	1	< 0.1%
2.131995793	1	< 0.1%

zyklus_
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	113578
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32472.33152

Minimum	0
Maximum	113577
Zeros	28
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1996
Q1	10087
median	22971
Q3	44851
95-th percentile	96975
Maximum	113577
Range	113577
Interquartile range (IQR)	34764

Descriptive statistics

Standard deviation	29157.94647
Coefficient of variation (CV)	0.8979320274
Kurtosis	0.2050848016
Mean	32472.33152
Median Absolute Deviation (MAD)	15201
Skewness	1.106899109
Sum	3.630062457 × 10¹⁰
Variance	850185842.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28	< 0.1%
4738	28	< 0.1%
4749	28	< 0.1%
4748	28	< 0.1%
4747	28	< 0.1%
4746	28	< 0.1%
4745	28	< 0.1%
4744	28	< 0.1%
4743	28	< 0.1%
4742	28	< 0.1%
Other values (113568)	1117614	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	28	< 0.1%
1	28	< 0.1%
2	28	< 0.1%
3	28	< 0.1%
4	28	< 0.1%
5	28	< 0.1%
6	28	< 0.1%
7	28	< 0.1%
8	28	< 0.1%
9	28	< 0.1%

Value	Count	Frequency (%)
113577	1	< 0.1%
113576	1	< 0.1%
113575	1	< 0.1%
113574	1	< 0.1%
113573	1	< 0.1%
113572	1	< 0.1%
113571	1	< 0.1%
113570	1	< 0.1%
113569	1	< 0.1%
113568	1	< 0.1%

comment_
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

rest (random walk)	520051
discharge (random walk)	425240
charge (random walk)	109833
rest post random walk discharge	24699
charge (after random walk discharge)	21513
Other values (18)	16558

Length

Max length	36
Median length	20
Mean length	20.78333813
Min length	16

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	low current discharge at 0.04A
2nd row	low current charge
3rd row	reference charge
4th row	reference discharge
5th row	reference charge

Common Values

Value	Count	Frequency (%)
rest (random walk)	520051	46.5%
discharge (random walk)	425240	38.0%
charge (random walk)	109833	9.8%
rest post random walk discharge	24699	2.2%
charge (after random walk discharge)	21513	1.9%
pulsed load (discharge)	5068	0.5%
pulsed load (rest)	5029	0.4%
reference charge	950	0.1%
reference discharge	950	0.1%
pulsed charge (charge)	853	0.1%
Other values (13)	3708	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
random	1101336	31.9%
walk	1101336	31.9%
rest	553151	16.0%
discharge	479123	13.9%
charge	135719	3.9%
post	26900	0.8%
after	21513	0.6%
pulsed	12289	0.4%
load	10583	0.3%
reference	4182	0.1%
Other values (7)	1287	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

type_
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

R	561172
D	423810
C	132912

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	C
3rd row	C
4th row	D
5th row	C

Common Values

Value	Count	Frequency (%)
R	561172	50.2%
D	423810	37.9%
C	132912	11.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
r	561172	50.2%
d	423810	37.9%
c	132912	11.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

temperature_amax
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	41837
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-70.04370649

Minimum	-4099.44775
Maximum	59.78934
Zeros	0
Zeros (%)	0.0%
Negative	28608
Negative (%)	2.6%
Memory size	8.5 MiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	20.55078
Q1	26.2608
median	31.74998
Q3	39.58841
95-th percentile	47.6367
Maximum	59.78934
Range	4159.23709
Interquartile range (IQR)	13.32761

Descriptive statistics

Standard deviation	644.3293729
Coefficient of variation (CV)	-9.198961695
Kurtosis	34.93001804
Mean	-70.04370649
Median Absolute Deviation (MAD)	6.19929
Skewness	-6.075094837
Sum	-78301439.22
Variance	415160.3408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	13395	1.2%
-4094.09814	9175	0.8%
-4099.44775	3300	0.3%
-4059.5376	1978	0.2%
25.4008	327	< 0.1%
25.92998	312	< 0.1%
24.43581	306	< 0.1%
36.97732	303	< 0.1%
25.30741	300	< 0.1%
24.99612	300	< 0.1%
Other values (41827)	1088198	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	3300	0.3%
-4094.09814	9175	0.8%
-4093.927	13395	1.2%
-4089.49561	2	< 0.1%
-4084.72437	1	< 0.1%
-4083.25146	1	< 0.1%
-4077.05518	1	< 0.1%
-4071.2605	1	< 0.1%
-4059.5376	1978	0.2%
-4055.58179	1	< 0.1%

Value	Count	Frequency (%)
59.78934	1	< 0.1%
59.71331	1	< 0.1%
58.96771	2	< 0.1%
58.73773	1	< 0.1%
58.66168	2	< 0.1%
58.64647	2	< 0.1%
58.61578	2	< 0.1%
58.5716	2	< 0.1%
58.41876	2	< 0.1%
58.40967	2	< 0.1%

temperature_amin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	42013
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-75.54420326

Minimum	-4099.44775
Maximum	58.64647
Zeros	0
Zeros (%)	0.0%
Negative	29984
Negative (%)	2.7%
Memory size	8.5 MiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	19.77053
Q1	25.60313
median	31.18026
Q3	38.86047
95-th percentile	47.20129
Maximum	58.64647
Range	4158.09422
Interquartile range (IQR)	13.25734

Descriptive statistics

Standard deviation	659.0978893
Coefficient of variation (CV)	-8.724665306
Kurtosis	33.11310627
Mean	-75.54420326
Median Absolute Deviation (MAD)	6.28955
Skewness	-5.923924832
Sum	-84450411.56
Variance	434410.0276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	14537	1.3%
-4094.09814	9176	0.8%
-4099.44775	3432	0.3%
-4059.5376	2060	0.2%
23.81324	324	< 0.1%
25.4008	320	< 0.1%
24.99612	312	< 0.1%
25.08951	312	< 0.1%
25.28563	311	< 0.1%
24.21791	310	< 0.1%
Other values (42003)	1086800	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	3432	0.3%
-4094.09814	9176	0.8%
-4093.927	14537	1.3%
-4089.49561	2	< 0.1%
-4088.13281	1	< 0.1%
-4086.08716	1	< 0.1%
-4084.72437	1	< 0.1%
-4083.25146	1	< 0.1%
-4077.05518	2	< 0.1%
-4073.64624	1	< 0.1%

Value	Count	Frequency (%)
58.64647	1	< 0.1%
58.25102	1	< 0.1%
58.06852	2	< 0.1%
58.04459	2	< 0.1%
58.0381	2	< 0.1%
57.99247	1	< 0.1%
57.97726	2	< 0.1%
57.85558	3	< 0.1%
57.77954	2	< 0.1%
57.76433	2	< 0.1%

temperature_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	571541
Distinct (%)	51.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.56557161

Minimum	-4099.44775
Maximum	58.64647
Zeros	0
Zeros (%)	0.0%
Negative	29832
Negative (%)	2.7%
Memory size	8.5 MiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	20.15407207
Q1	25.88329
median	31.41023913
Q3	39.24945861
95-th percentile	47.33323855
Maximum	58.64647
Range	4158.09422
Interquartile range (IQR)	13.36616861

Descriptive statistics

Standard deviation	651.9462108
Coefficient of variation (CV)	-8.862110313
Kurtosis	33.73386826
Mean	-73.56557161
Median Absolute Deviation (MAD)	6.223209131
Skewness	-5.972256111
Sum	-82238511.1
Variance	425033.8618
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	12915	1.2%
-4094.09814	8819	0.8%
-4099.44775	3300	0.3%
-4059.5376	1968	0.2%
-4093.927	480	< 0.1%
-4094.09814	356	< 0.1%
23.81324	169	< 0.1%
24.524	169	< 0.1%
25.28563	166	< 0.1%
25.4008	162	< 0.1%
Other values (571531)	1089390	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	3300	0.3%
-4094.09814	356	< 0.1%
-4094.09814	8819	0.8%
-4093.927	480	< 0.1%
-4093.927	12915	1.2%
-4093.880091	1	< 0.1%
-4093.830088	1	< 0.1%
-4093.809222	1	< 0.1%
-4093.510848	1	< 0.1%
-4093.43715	1	< 0.1%

Value	Count	Frequency (%)
58.64647	1	< 0.1%
58.43728	1	< 0.1%
58.3189834	1	< 0.1%
58.25863	1	< 0.1%
58.16799869	1	< 0.1%
58.0991818	1	< 0.1%
58.06852	1	< 0.1%
58.05056393	1	< 0.1%
58.04459	2	< 0.1%
58.0381	1	< 0.1%

time_amin
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1117397
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5779503.359

Minimum	5.04
Maximum	17607056.33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	5.04
5-th percentile	547129.167
Q1	2524378.915
median	5335860.175
Q3	8458769.213
95-th percentile	12524215.22
Maximum	17607056.33
Range	17607051.29
Interquartile range (IQR)	5934390.298

Descriptive statistics

Standard deviation	3901812.66
Coefficient of variation (CV)	0.6751121018
Kurtosis	-0.4682331604
Mean	5779503.359
Median Absolute Deviation (MAD)	2928068.46
Skewness	0.5435026405
Sum	6.460872128 × 10¹²
Variance	1.522414203 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60.04	11	< 0.1%
6373783.04	2	< 0.1%
1923777.7	2	< 0.1%
60.23	2	< 0.1%
1922613.16	2	< 0.1%
5056861.39	2	< 0.1%
7849722.38	2	< 0.1%
619398.22	2	< 0.1%
3525077.12	2	< 0.1%
11620776.83	2	< 0.1%
Other values (1117387)	1117865	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5.04	2	< 0.1%
5.1	1	< 0.1%
6.62	1	< 0.1%
60.04	11	< 0.1%
60.05	1	< 0.1%
60.23	2	< 0.1%
60.25	1	< 0.1%
60.28	1	< 0.1%
1126.99	1	< 0.1%
1538.07	1	< 0.1%

Value	Count	Frequency (%)
17607056.33	1	< 0.1%
17606756.3	1	< 0.1%
17603941.31	1	< 0.1%
17603889.54	1	< 0.1%
17603889.3	1	< 0.1%
17603829.33	1	< 0.1%
17603829.07	1	< 0.1%
17602256.61	1	< 0.1%
17602256.5	1	< 0.1%
17602255.63	1	< 0.1%

time_entladen_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	144391
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180321.1266

Minimum	0
Maximum	594530.06
Zeros	568
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	18927.94
Q1	89388.45
median	165653.73
Q3	262154.47
95-th percentile	362480.56
Maximum	594530.06
Range	594530.06
Interquartile range (IQR)	172766.02

Descriptive statistics

Standard deviation	114013.6962
Coefficient of variation (CV)	0.6322814102
Kurtosis	0.301324253
Mean	180321.1266
Median Absolute Deviation (MAD)	85273.94
Skewness	0.6347070008
Sum	2.015799055 × 10¹¹
Variance	1.299912292 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	568	0.1%
300	155	< 0.1%
151340.62	150	< 0.1%
137434.53	118	< 0.1%
600	118	< 0.1%
31263.23	114	< 0.1%
56564.46	114	< 0.1%
98853.3	112	< 0.1%
105957.72	112	< 0.1%
242250.17	110	< 0.1%
Other values (144381)	1116223	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	568	0.1%
0.01	4	< 0.1%
287.68	32	< 0.1%
300	155	< 0.1%
300.01	41	< 0.1%
300.02	11	< 0.1%
300.03	6	< 0.1%
347.68	2	< 0.1%
364.23	5	< 0.1%
407.68	2	< 0.1%

Value	Count	Frequency (%)
594530.06	2	< 0.1%
594472.51	6	< 0.1%
594435.32	4	< 0.1%
594399.82	4	< 0.1%
594346.12	4	< 0.1%
594292.21	4	< 0.1%
594237.41	4	< 0.1%
594230.13	2	< 0.1%
594170.13	4	< 0.1%
594168.88	4	< 0.1%

time_entladen_leicht_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	279113
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1274444.71

Minimum	0
Maximum	4369229.81
Zeros	37
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	72243.49
Q1	318299.15
median	830223.495
Q3	1997053.365
95-th percentile	3883537.143
Maximum	4369229.81
Range	4369229.81
Interquartile range (IQR)	1678754.215

Descriptive statistics

Standard deviation	1206459.564
Coefficient of variation (CV)	0.9466550837
Kurtosis	-0.1877695372
Mean	1274444.71
Median Absolute Deviation (MAD)	597608.915
Skewness	1.023328297
Sum	1.424694095 × 10¹²
Variance	1.455544679 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
378415.23	68	< 0.1%
561542.09	64	< 0.1%
392498.24	62	< 0.1%
155801.5	62	< 0.1%
272910.42	60	< 0.1%
510747.4	58	< 0.1%
31050.83	58	< 0.1%
472302.94	56	< 0.1%
1952315.07	56	< 0.1%
4075528.38	54	< 0.1%
Other values (279103)	1117296	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37	< 0.1%
7538.12	2	< 0.1%
7539.59	2	< 0.1%
7542.95	2	< 0.1%
7552.6	2	< 0.1%
7610.03	7	< 0.1%
7616.33	7	< 0.1%
7629.05	7	< 0.1%
7634.98	7	< 0.1%
7661.04	7	< 0.1%

Value	Count	Frequency (%)
4369229.81	6	< 0.1%
4369111.13	20	< 0.1%
4369109.66	2	< 0.1%
4368969.85	8	< 0.1%
4368669.85	4	< 0.1%
4368612.45	4	< 0.1%
4368611.64	2	< 0.1%
4368565.7	14	< 0.1%
4368565.21	2	< 0.1%
4368556.95	4	< 0.1%

time_laden_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	89181
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2818229.002

Minimum	0
Maximum	10915483.91
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	205758.65
Q1	1198590.79
median	2562775.87
Q3	4068391.62
95-th percentile	6747550.87
Maximum	10915483.91
Range	10915483.91
Interquartile range (IQR)	2869800.83

Descriptive statistics

Standard deviation	2025813.435
Coefficient of variation (CV)	0.7188249902
Kurtosis	1.050251071
Mean	2818229.002
Median Absolute Deviation (MAD)	1430975.66
Skewness	0.9537177129
Sum	3.150481292 × 10¹²
Variance	4.103920072 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30926.87	3336	0.3%
45485.58	3332	0.3%
47752.61	3072	0.3%
65091.73	2048	0.2%
64965.14	1838	0.2%
50677.12	1752	0.2%
107133.97	148	< 0.1%
50763.51	142	< 0.1%
660927.42	140	< 0.1%
142718.24	140	< 0.1%
Other values (89171)	1101946	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10	< 0.1%
1627.08	2	< 0.1%
6289.18	2	< 0.1%
9394.74	4	< 0.1%
9440.27	4	< 0.1%
9440.8	4	< 0.1%
9453.07	4	< 0.1%
9489.58	4	< 0.1%
9606.3	4	< 0.1%
9657.97	4	< 0.1%

Value	Count	Frequency (%)
10915483.91	12	< 0.1%
10906299.36	16	< 0.1%
10899303.96	10	< 0.1%
10892484.17	10	< 0.1%
10869491.32	18	< 0.1%
10850409.36	4	< 0.1%
10846895.28	7	< 0.1%
10839779.61	14	< 0.1%
10839556.97	12	< 0.1%
10833802.61	8	< 0.1%

time_pause_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	560650
Distinct (%)	50.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	889490.5416

Minimum	0
Maximum	5770552.51
Zeros	71
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	46880.21
Q1	217789.74
median	649647.84
Q3	1163133.353
95-th percentile	2651651.051
Maximum	5770552.51
Range	5770552.51
Interquartile range (IQR)	945343.6125

Descriptive statistics

Standard deviation	898308.0015
Coefficient of variation (CV)	1.009912933
Kurtosis	4.315897176
Mean	889490.5416
Median Absolute Deviation (MAD)	462551.215
Skewness	1.876990027
Sum	9.943561395 × 10¹¹
Variance	8.069572656 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71	< 0.1%
6000	54	< 0.1%
300	34	< 0.1%
18600	32	< 0.1%
25800	32	< 0.1%
24600	32	< 0.1%
22200	32	< 0.1%
21000	32	< 0.1%
19800	32	< 0.1%
16200	32	< 0.1%
Other values (560640)	1117511	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	71	< 0.1%
300	34	< 0.1%
1200	22	< 0.1%
2400	22	< 0.1%
3600	22	< 0.1%
4800	22	< 0.1%
5700	32	< 0.1%
6000	54	< 0.1%
7200	22	< 0.1%
8400	22	< 0.1%

Value	Count	Frequency (%)
5770552.51	2	< 0.1%
5770552.35	2	< 0.1%
5770552.17	2	< 0.1%
5766952.17	2	< 0.1%
5766951.86	2	< 0.1%
5766951.68	2	< 0.1%
5766951.46	2	< 0.1%
5763351.46	2	< 0.1%
5763351.23	2	< 0.1%
5759751.23	2	< 0.1%

time_temp_hoch
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	27116
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133.2959911

Minimum	0
Maximum	169171.2
Zeros	475649
Zeros (%)	42.5%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	38.54
95-th percentile	300
Maximum	169171.2
Range	169171.2
Interquartile range (IQR)	38.54

Descriptive statistics

Standard deviation	977.7642105
Coefficient of variation (CV)	7.33528595
Kurtosis	6415.326839
Mean	133.2959911
Median Absolute Deviation (MAD)	0.2
Skewness	46.20583322
Sum	149010788.6
Variance	956022.8513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	475649	42.5%
60	167120	14.9%
300	56626	5.1%
0.86	32071	2.9%
0.01	15343	1.4%
0.18	12426	1.1%
0.17	12138	1.1%
0.16	10721	1.0%
3600	10698	1.0%
0.2	10685	1.0%
Other values (27106)	314417	28.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	475649	42.5%
0.01	15343	1.4%
0.02	4937	0.4%
0.03	796	0.1%
0.04	2424	0.2%
0.05	546	< 0.1%
0.06	390	< 0.1%
0.07	301	< 0.1%
0.08	205	< 0.1%
0.09	160	< 0.1%

Value	Count	Frequency (%)
169171.2	1	< 0.1%
166952.01	1	< 0.1%
166526.96	1	< 0.1%
166483.78	1	< 0.1%
162000.77	1	< 0.1%
156799.19	1	< 0.1%
154401.04	1	< 0.1%
154087.97	1	< 0.1%
136924.89	1	< 0.1%
134432.07	1	< 0.1%

time_temp_hoch_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	642226
Distinct (%)	57.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2501567.533

Minimum	0
Maximum	11416948.64
Zeros	684
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 MiB

Quantile statistics

Minimum	0
5-th percentile	188048.3215
Q1	663568.01
median	1485936.5
Q3	3736390.243
95-th percentile	7798453.685
Maximum	11416948.64
Range	11416948.64
Interquartile range (IQR)	3072822.233

Descriptive statistics

Standard deviation	2419130.569
Coefficient of variation (CV)	0.9670458772
Kurtosis	0.2881428619
Mean	2501567.533
Median Absolute Deviation (MAD)	1080925.04
Skewness	1.163548805
Sum	2.796487336 × 10¹²
Variance	5.852192711 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
405611.66	13208	1.2%
405011.46	12024	1.1%
1341971.38	9277	0.8%
1578427.2	9179	0.8%
1497579.63	7161	0.6%
1469602.17	6428	0.6%
3739006.82	5021	0.4%
801984.51	4898	0.4%
1682809.07	4749	0.4%
801217.41	4205	0.4%
Other values (642216)	1041744	93.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	684	0.1%
300	16	< 0.1%
300.17	1	< 0.1%
300.18	1	< 0.1%
300.19	1	< 0.1%
300.22	1	< 0.1%
300.24	1	< 0.1%
300.58	1	< 0.1%
300.78	1	< 0.1%
301.22	1	< 0.1%

Value	Count	Frequency (%)
11416948.64	1	< 0.1%
11409748.64	1	< 0.1%
11406004.18	1	< 0.1%
11405704.18	1	< 0.1%
11394828.5	1	< 0.1%
11394648.67	1	< 0.1%
11394647.79	1	< 0.1%
11389247.79	1	< 0.1%
11389247.01	1	< 0.1%
11385647.01	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	batteryname_	amperestunden	zyklus_	comment_	type_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher
0	RW1	2.094997	0	low current discharge at 0.04A	D	18.79972	17.08313	17.939268	1538.07	188976.68	0.00	0.0
1	RW1	-2.120549	1	low current charge	C	18.64223	17.06738	17.867832	190514.75	188976.68	191271.64	0.0
2	RW1	-0.021099	2	reference charge	C	18.37451	18.09103	18.232178	381786.29	188976.68	194718.28	0.0
3	RW1	2.000364	3	reference discharge	D	23.56742	18.39025	21.798768	385232.92	196178.50	194718.28	0.0
4	RW1	-2.005160	4	reference charge	C	25.28264	17.69732	20.055134	392434.74	196178.50	207816.73	0.0
5	RW1	2.000250	5	reference discharge	D	24.06639	18.15403	21.449898	405533.19	203379.98	207816.73	0.0
6	RW1	0.000000	6	pulsed load (rest)	R	18.35876	17.82331	18.001093	425723.63	203379.98	207816.73	1200.0
7	RW1	0.166649	7	pulsed load (discharge)	D	19.83912	18.23277	19.234778	426923.66	203979.98	207816.73	1200.0
8	RW1	0.000000	8	pulsed load (rest)	R	19.83912	18.76822	19.351673	427523.63	203979.98	207816.73	2400.0
9	RW1	0.166652	9	pulsed load (discharge)	D	20.97899	19.24067	20.080216	428723.66	204579.98	207816.73	2400.0

Last rows

	batteryname_	amperestunden	zyklus_	comment_	type_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_stark_vorher	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher	time_temp_hoch	time_temp_hoch_vorher
1117884	RW9	0.000000	113568	rest (random walk)	R	38.80146	38.78600	38.793730	12641068.65	319549.85	4139735.62	5113269.55	1093976.63	1.14	9.360014e+06
1117885	RW9	0.062502	113569	discharge (random walk)	D	38.87875	38.32224	38.637165	12641069.82	319549.85	4140035.62	5113269.55	1093976.63	300.00	9.360314e+06
1117886	RW9	-1.077257	113570	reference charge	C	38.32224	31.36576	33.218995	12641369.82	319549.85	4140035.62	5144349.95	1093976.63	31080.40	9.391394e+06
1117887	RW9	0.000000	113571	rest post reference charge	R	32.40151	32.37059	32.381562	12672450.19	319549.85	4140035.62	5144349.95	1094276.63	300.00	9.391694e+06
1117888	RW9	0.748778	113572	reference discharge	D	38.29132	32.40151	35.719393	12672750.22	319549.85	4142731.52	5144349.95	1094276.63	2695.90	9.394390e+06
1117889	RW9	0.000000	113573	rest post reference discharge	R	38.29132	30.73195	32.874813	12675446.09	319549.85	4142731.52	5144349.95	1101476.63	7200.00	9.401590e+06
1117890	RW9	-0.774939	113574	reference charge	C	34.13290	30.76287	32.242548	12682646.12	319549.85	4142731.52	5164882.66	1101476.63	20532.71	9.422123e+06
1117891	RW9	0.000000	113575	rest post reference charge	R	32.47880	32.40151	32.446385	12703178.80	319549.85	4142731.52	5164882.66	1101776.63	300.00	9.422423e+06
1117892	RW9	0.750203	113576	reference discharge	D	38.86329	32.46334	35.958514	12703478.83	319549.85	4145432.36	5164882.66	1101776.63	2700.84	9.425124e+06
1117893	RW9	0.000000	113577	rest post reference discharge	R	38.86329	32.15417	33.766021	12706179.64	319549.85	4145432.36	5164882.66	1108976.63	7200.00	9.432324e+06

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows